/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50711
 Source Host           : localhost
 Source Database       : doctor

 Target Server Type    : MySQL
 Target Server Version : 50711
 File Encoding         : utf-8

 Date: 03/15/2016 00:37:37 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `Symptoms`
-- ----------------------------
DROP TABLE IF EXISTS `Symptoms`;
CREATE TABLE `Symptoms` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `parentId` int(11) DEFAULT NULL,
  `treepath` varchar(500) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `priority` int(7) DEFAULT NULL,
  `code` varchar(50) DEFAULT NULL,
  `comment` varchar(500) DEFAULT NULL,
  `leaf` bit(1) NOT NULL DEFAULT b'1',
  `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updateTime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `Symptoms`
-- ----------------------------
BEGIN;
INSERT INTO `Symptoms` VALUES ('1', '0', null, '白带异常', null, 'A001', null, b'0', '2016-03-14 22:32:07', '2016-03-14 23:59:30'), ('2', '1', null, '伴有外阴瘙痒', null, 'A002', null, b'0', '2016-03-14 22:32:20', '2016-03-14 23:59:31'), ('3', '1', null, '不伴有外阴瘙痒', null, 'A003', null, b'0', '2016-03-14 22:32:36', '2016-03-14 23:59:32'), ('4', '2', null, '灰黄色、黄白色泡沫状稀薄白带', null, 'A004', null, b'0', '2016-03-14 22:32:40', '2016-03-14 23:59:34'), ('5', '2', null, '豆腐渣样白带或凝乳样白带', null, 'A005', null, b'0', '2016-03-14 22:33:01', '2016-03-14 23:59:35'), ('6', '2', null, '灰白色均值鱼腥味白带', null, 'A006', null, b'0', '2016-03-14 22:33:06', '2016-03-14 23:59:35'), ('7', '2', null, '黄色、黄绿色脓性白带', null, 'A007', null, b'0', '2016-03-14 22:33:11', '2016-03-14 23:59:36'), ('8', '2', null, '黄色、黄绿色脓性白带', null, 'A007a', null, b'0', '2016-03-14 22:33:16', '2016-03-14 23:59:37'), ('9', '3', null, '血性白带：白带中带血', null, 'A008', null, b'0', '2016-03-14 22:33:22', '2016-03-14 23:59:38'), ('10', '3', null, '淘米水样白带伴有明显臭味', null, 'A009', null, b'0', '2016-03-14 22:33:27', '2016-03-14 23:59:39'), ('11', '3', null, '间歇性大量水样或淡血性白带', null, 'A010', null, b'0', '2016-03-14 22:34:00', '2016-03-14 23:59:41'), ('12', '4', null, '滴虫性阴道炎', null, 'A011', null, b'1', '2016-03-14 22:34:50', '2016-03-14 23:59:43'), ('13', '5', null, '假丝酵母菌性阴道炎', null, 'A012', null, b'1', '2016-03-14 22:34:55', '2016-03-14 23:59:45'), ('14', '6', null, '细菌性阴道病', null, 'A013', null, b'1', '2016-03-14 22:35:00', '2016-03-14 23:59:46'), ('15', '7', null, '无下腹痛(非经期）', null, 'A014', null, b'0', '2016-03-14 22:35:03', '2016-03-14 23:59:48'), ('16', '7', null, '非经期持续性下腹痛', null, 'A015', null, b'0', '2016-03-14 22:35:07', '2016-03-14 23:59:50'), ('17', '9', null, '慢性宫颈炎', null, 'A016', null, b'1', '2016-03-14 22:35:12', '2016-03-14 23:59:55'), ('18', '9', null, '宫颈柱状上皮异味', null, 'A017', null, b'0', '2016-03-14 22:35:18', '2016-03-14 23:59:56'), ('19', '9', null, '宫颈息肉', null, 'A018', null, b'1', '2016-03-14 22:35:23', '2016-03-15 00:00:09'), ('20', '9', null, '子宫黏膜下肌瘤', null, 'A019', null, b'1', '2016-03-14 22:35:29', '2016-03-15 00:00:10'), ('21', '9', null, '宫颈上皮内瘤样变', null, 'A020', null, b'1', '2016-03-14 22:35:34', '2016-03-15 00:00:11'), ('22', '9', null, '子宫内膜癌可能', null, 'A021', null, b'1', '2016-03-14 22:35:38', '2016-03-15 00:00:11'), ('23', '9', null, '子宫内膜癌可能', null, 'A022', null, b'1', '2016-03-14 22:35:44', '2016-03-15 00:00:12'), ('24', '10', null, '宫颈癌可能', null, 'A023', null, b'1', '2016-03-14 22:35:48', '2016-03-15 00:00:13'), ('25', '11', null, '输卵管癌可能', null, 'A024', null, b'1', '2016-03-14 22:35:51', '2016-03-15 00:00:13'), ('26', '15', null, '阴道炎', null, 'A025', null, b'1', '2016-03-14 22:35:57', '2016-03-15 00:00:14'), ('27', '15', null, '慢性宫颈炎', null, 'A026', null, b'1', '2016-03-14 22:36:06', '2016-03-15 00:00:15'), ('28', '15', null, '宫颈柱状上皮异位（宫颈糜烂）', null, 'A027', null, b'1', '2016-03-14 22:36:14', '2016-03-15 00:00:16'), ('29', '16', null, '急性宫颈炎', null, 'A028', null, b'1', '2016-03-14 22:36:20', '2016-03-15 00:00:18'), ('30', '16', null, '慢性子宫内膜炎', null, 'A029', null, b'1', '2016-03-14 22:36:24', '2016-03-15 00:00:19'), ('31', '16', null, '粘膜下肌瘤伴感染', null, 'A030', null, b'1', '2016-03-14 22:36:30', '2016-03-15 00:00:20'), ('32', '16', null, '慢性输卵管感染', null, 'A031', null, b'1', '2016-03-14 22:36:34', '2016-03-15 00:00:17');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
